Enter Asset File Filters Tab

If desired, use the filter controls to help determine which files the query will return. These filter selections can be used in addition to the Query Criteria but the query cannot be run solely with these filters. Note: The Enter Asset File Filters tab is only for the Asset File query.

The File Date controls allow the manager to establish a date range for the query results. The File Type dropdown determines if all file types or a specific file type will be queried.

The File Name and File Description textboxes allow the manager to filter based on a specific file name or description. These textboxes operate under the "Contain" control, therefore all asset files that contain the entry (and meet the other specified criteria) will be present in the query results.

The Category dropdown can be used to specify a specific file category to filter.

Run Query

When a new query is complete or a saved query has been loaded, click the Run Query button in the top right corner of the screen to view the results of the query:

Depending on the query type, various buttons will be available to edit the results, show the resulting assets on a map, or export the results.

Edit Query Results

When a query is run, the user may have the ability to edit the results depending on the returned items and display criteria.

Note: Editing query results is typically only available to administrators. Editing controls are available on the report, asset file, and maintenance query types.

Click the Edit Results button to reveal the display columns that can be edited:

Make the desired changes, then click the Done Editing button.